﻿using System.Configuration;
using System.Data;
using Microsoft.ApplicationBlocks.Data;

namespace Customs.Components.SLXNK
{
	public class Nuoc
	{
		public static DataTable SelectAll()
		{
			string connectionString = ConfigurationManager.AppSettings["SLXNKConnectionString"];
			string query = "SELECT * FROM SNUOC ORDER BY TEN_NUOC;";
			DataTable dt = SqlHelper.ExecuteDataset(connectionString, CommandType.Text, query).Tables[0];
			DataRow row = dt.NewRow();
			row["Ma_Nuoc"] = "   ";
			row["Ten_Nuoc"] = "[Tất cả]";
			dt.Rows.Add(row);
			return dt;
		}
	}
}
